3 * Representation of a page version.
5 * This program is free software; you can redistribute it and/or modify
6 * it under the terms of the GNU General Public License as published by
7 * the Free Software Foundation; either version 2 of the License, or
8 * (at your option) any later version.
10 * This program is distributed in the hope that it will be useful,
11 * but WITHOUT ANY WARRANTY; without even the implied warranty of
12 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 * GNU General Public License for more details.
15 * You should have received a copy of the GNU General Public License along
16 * with this program; if not, write to the Free Software Foundation, Inc.,
17 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
18 * http://www.gnu.org/copyleft/gpl.html
30 protected $mOrigUserText;
32 protected $mMinorEdit;
33 protected $mTimestamp;
44 const DELETED_TEXT
= 1;
45 const DELETED_COMMENT
= 2;
46 const DELETED_USER
= 4;
47 const DELETED_RESTRICTED
= 8;
49 const SUPPRESSED_USER
= 12;
50 // Audience options for Revision::getText()
52 const FOR_THIS_USER
= 2;
56 * Load a page revision from a given revision ID number.
57 * Returns null if no such revision can be found.
60 * @return Revision or null
62 public static function newFromId( $id ) {
63 return Revision
::newFromConds( array( 'rev_id' => intval( $id ) ) );
67 * Load either the current, or a specified, revision
68 * that's attached to a given title. If not attached
69 * to that title, will return null.
72 * @param $id Integer (optional)
73 * @return Revision or null
75 public static function newFromTitle( $title, $id = 0 ) {
77 'page_namespace' => $title->getNamespace(),
78 'page_title' => $title->getDBkey()
81 // Use the specified ID
82 $conds['rev_id'] = $id;
83 } elseif ( wfGetLB()->getServerCount() > 1 ) {
84 // Get the latest revision ID from the master
85 $dbw = wfGetDB( DB_MASTER
);
86 $latest = $dbw->selectField( 'page', 'page_latest', $conds, __METHOD__
);
87 if ( $latest === false ) {
88 return null; // page does not exist
90 $conds['rev_id'] = $latest;
92 // Use a join to get the latest revision
93 $conds[] = 'rev_id=page_latest';
95 return Revision
::newFromConds( $conds );
99 * Load either the current, or a specified, revision
100 * that's attached to a given page ID.
101 * Returns null if no such revision can be found.
103 * @param $revId Integer
104 * @param $pageId Integer (optional)
105 * @return Revision or null
107 public static function newFromPageId( $pageId, $revId = 0 ) {
108 $conds = array( 'page_id' => $pageId );
110 $conds['rev_id'] = $revId;
111 } elseif ( wfGetLB()->getServerCount() > 1 ) {
112 // Get the latest revision ID from the master
113 $dbw = wfGetDB( DB_MASTER
);
114 $latest = $dbw->selectField( 'page', 'page_latest', $conds, __METHOD__
);
115 if ( $latest === false ) {
116 return null; // page does not exist
118 $conds['rev_id'] = $latest;
120 $conds[] = 'rev_id = page_latest';
122 return Revision
::newFromConds( $conds );
126 * Make a fake revision object from an archive table row. This is queried
127 * for permissions or even inserted (as in Special:Undelete)
128 * @todo FIXME: Should be a subclass for RevisionDelete. [TS]
131 * @param $overrides array
135 public static function newFromArchiveRow( $row, $overrides = array() ) {
136 $attribs = $overrides +
array(
137 'page' => isset( $row->ar_page_id
) ?
$row->ar_page_id
: null,
138 'id' => isset( $row->ar_rev_id
) ?
$row->ar_rev_id
: null,
139 'comment' => $row->ar_comment
,
140 'user' => $row->ar_user
,
141 'user_text' => $row->ar_user_text
,
142 'timestamp' => $row->ar_timestamp
,
143 'minor_edit' => $row->ar_minor_edit
,
144 'text_id' => isset( $row->ar_text_id
) ?
$row->ar_text_id
: null,
145 'deleted' => $row->ar_deleted
,
146 'len' => $row->ar_len
,
147 'sha1' => isset( $row->ar_sha1
) ?
$row->ar_sha1
: null,
149 if ( isset( $row->ar_text
) && !$row->ar_text_id
) {
150 // Pre-1.5 ar_text row
151 $attribs['text'] = self
::getRevisionText( $row, 'ar_' );
152 if ( $attribs['text'] === false ) {
153 throw new MWException( 'Unable to load text from archive row (possibly bug 22624)' );
156 return new self( $attribs );
165 public static function newFromRow( $row ) {
166 return new self( $row );
170 * Load a page revision from a given revision ID number.
171 * Returns null if no such revision can be found.
173 * @param $db DatabaseBase
175 * @return Revision or null
177 public static function loadFromId( $db, $id ) {
178 return Revision
::loadFromConds( $db, array( 'rev_id' => intval( $id ) ) );
182 * Load either the current, or a specified, revision
183 * that's attached to a given page. If not attached
184 * to that page, will return null.
186 * @param $db DatabaseBase
187 * @param $pageid Integer
189 * @return Revision or null
191 public static function loadFromPageId( $db, $pageid, $id = 0 ) {
192 $conds = array( 'rev_page' => intval( $pageid ), 'page_id' => intval( $pageid ) );
194 $conds['rev_id'] = intval( $id );
196 $conds[] = 'rev_id=page_latest';
198 return Revision
::loadFromConds( $db, $conds );
202 * Load either the current, or a specified, revision
203 * that's attached to a given page. If not attached
204 * to that page, will return null.
206 * @param $db DatabaseBase
207 * @param $title Title
209 * @return Revision or null
211 public static function loadFromTitle( $db, $title, $id = 0 ) {
213 $matchId = intval( $id );
215 $matchId = 'page_latest';
217 return Revision
::loadFromConds( $db,
218 array( "rev_id=$matchId",
219 'page_namespace' => $title->getNamespace(),
220 'page_title' => $title->getDBkey() )
225 * Load the revision for the given title with the given timestamp.
226 * WARNING: Timestamps may in some circumstances not be unique,
227 * so this isn't the best key to use.
229 * @param $db DatabaseBase
230 * @param $title Title
231 * @param $timestamp String
232 * @return Revision or null
234 public static function loadFromTimestamp( $db, $title, $timestamp ) {
235 return Revision
::loadFromConds( $db,
236 array( 'rev_timestamp' => $db->timestamp( $timestamp ),
237 'page_namespace' => $title->getNamespace(),
238 'page_title' => $title->getDBkey() )
243 * Given a set of conditions, fetch a revision.
245 * @param $conditions Array
246 * @return Revision or null
248 public static function newFromConds( $conditions ) {
249 $db = wfGetDB( DB_SLAVE
);
250 $rev = Revision
::loadFromConds( $db, $conditions );
251 if( is_null( $rev ) && wfGetLB()->getServerCount() > 1 ) {
252 $dbw = wfGetDB( DB_MASTER
);
253 $rev = Revision
::loadFromConds( $dbw, $conditions );
259 * Given a set of conditions, fetch a revision from
260 * the given database connection.
262 * @param $db DatabaseBase
263 * @param $conditions Array
264 * @return Revision or null
266 private static function loadFromConds( $db, $conditions ) {
267 $res = Revision
::fetchFromConds( $db, $conditions );
269 $row = $res->fetchObject();
271 $ret = new Revision( $row );
280 * Return a wrapper for a series of database rows to
281 * fetch all of a given page's revisions in turn.
282 * Each row can be fed to the constructor to get objects.
284 * @param $title Title
285 * @return ResultWrapper
287 public static function fetchRevision( $title ) {
288 return Revision
::fetchFromConds(
290 array( 'rev_id=page_latest',
291 'page_namespace' => $title->getNamespace(),
292 'page_title' => $title->getDBkey() )
297 * Given a set of conditions, return a ResultWrapper
298 * which will return matching database rows with the
299 * fields necessary to build Revision objects.
301 * @param $db DatabaseBase
302 * @param $conditions Array
303 * @return ResultWrapper
305 private static function fetchFromConds( $db, $conditions ) {
306 $fields = array_merge(
307 self
::selectFields(),
308 self
::selectPageFields(),
309 self
::selectUserFields()
312 array( 'revision', 'page', 'user' ),
316 array( 'LIMIT' => 1 ),
317 array( 'page' => self
::pageJoinCond(), 'user' => self
::userJoinCond() )
322 * Return the value of a select() JOIN conds array for the user table.
323 * This will get user table rows for logged-in users.
327 public static function userJoinCond() {
328 return array( 'LEFT JOIN', array( 'rev_user != 0', 'user_id = rev_user' ) );
332 * Return the value of a select() page conds array for the paeg table.
333 * This will assure that the revision(s) are not orphaned from live pages.
337 public static function pageJoinCond() {
338 return array( 'INNER JOIN', array( 'page_id = rev_page' ) );
342 * Return the list of revision fields that should be selected to create
346 public static function selectFields() {
364 * Return the list of text fields that should be selected to read the
368 public static function selectTextFields() {
376 * Return the list of page fields that should be selected from page table
379 public static function selectPageFields() {
389 * Return the list of user fields that should be selected from user table
392 public static function selectUserFields() {
393 return array( 'user_name' );
399 * @param $row Mixed: either a database row or an array
402 function __construct( $row ) {
403 if( is_object( $row ) ) {
404 $this->mId
= intval( $row->rev_id
);
405 $this->mPage
= intval( $row->rev_page
);
406 $this->mTextId
= intval( $row->rev_text_id
);
407 $this->mComment
= $row->rev_comment
;
408 $this->mUser
= intval( $row->rev_user
);
409 $this->mMinorEdit
= intval( $row->rev_minor_edit
);
410 $this->mTimestamp
= $row->rev_timestamp
;
411 $this->mDeleted
= intval( $row->rev_deleted
);
413 if( !isset( $row->rev_parent_id
) ) {
414 $this->mParentId
= is_null( $row->rev_parent_id
) ?
null : 0;
416 $this->mParentId
= intval( $row->rev_parent_id
);
419 if( !isset( $row->rev_len
) ||
is_null( $row->rev_len
) ) {
422 $this->mSize
= intval( $row->rev_len
);
425 if ( !isset( $row->rev_sha1
) ) {
428 $this->mSha1
= $row->rev_sha1
;
431 if( isset( $row->page_latest
) ) {
432 $this->mCurrent
= ( $row->rev_id
== $row->page_latest
);
433 $this->mTitle
= Title
::newFromRow( $row );
435 $this->mCurrent
= false;
436 $this->mTitle
= null;
439 // Lazy extraction...
441 if( isset( $row->old_text
) ) {
442 $this->mTextRow
= $row;
444 // 'text' table row entry will be lazy-loaded
445 $this->mTextRow
= null;
448 // Use user_name for users and rev_user_text for IPs...
449 $this->mUserText
= null; // lazy load if left null
450 if ( $this->mUser
== 0 ) {
451 $this->mUserText
= $row->rev_user_text
; // IP user
452 } elseif ( isset( $row->user_name
) ) {
453 $this->mUserText
= $row->user_name
; // logged-in user
455 $this->mOrigUserText
= $row->rev_user_text
;
456 } elseif( is_array( $row ) ) {
457 // Build a new revision to be saved...
458 global $wgUser; // ugh
460 $this->mId
= isset( $row['id'] ) ?
intval( $row['id'] ) : null;
461 $this->mPage
= isset( $row['page'] ) ?
intval( $row['page'] ) : null;
462 $this->mTextId
= isset( $row['text_id'] ) ?
intval( $row['text_id'] ) : null;
463 $this->mUserText
= isset( $row['user_text'] ) ?
strval( $row['user_text'] ) : $wgUser->getName();
464 $this->mUser
= isset( $row['user'] ) ?
intval( $row['user'] ) : $wgUser->getId();
465 $this->mMinorEdit
= isset( $row['minor_edit'] ) ?
intval( $row['minor_edit'] ) : 0;
466 $this->mTimestamp
= isset( $row['timestamp'] ) ?
strval( $row['timestamp'] ) : wfTimestampNow();
467 $this->mDeleted
= isset( $row['deleted'] ) ?
intval( $row['deleted'] ) : 0;
468 $this->mSize
= isset( $row['len'] ) ?
intval( $row['len'] ) : null;
469 $this->mParentId
= isset( $row['parent_id'] ) ?
intval( $row['parent_id'] ) : null;
470 $this->mSha1
= isset( $row['sha1'] ) ?
strval( $row['sha1'] ) : null;
472 // Enforce spacing trimming on supplied text
473 $this->mComment
= isset( $row['comment'] ) ?
trim( strval( $row['comment'] ) ) : null;
474 $this->mText
= isset( $row['text'] ) ?
rtrim( strval( $row['text'] ) ) : null;
475 $this->mTextRow
= null;
477 $this->mTitle
= null; # Load on demand if needed
478 $this->mCurrent
= false;
479 # If we still have no length, see it we have the text to figure it out
480 if ( !$this->mSize
) {
481 $this->mSize
= is_null( $this->mText
) ?
null : strlen( $this->mText
);
484 if ( $this->mSha1
=== null ) {
485 $this->mSha1
= is_null( $this->mText
) ?
null : self
::base36Sha1( $this->mText
);
488 throw new MWException( 'Revision constructor passed invalid row format.' );
490 $this->mUnpatrolled
= null;
496 * @return Integer|null
498 public function getId() {
503 * Set the revision ID
508 public function setId( $id ) {
515 * @return Integer|null
517 public function getTextId() {
518 return $this->mTextId
;
522 * Get parent revision ID (the original previous page revision)
524 * @return Integer|null
526 public function getParentId() {
527 return $this->mParentId
;
531 * Returns the length of the text in this revision, or null if unknown.
533 * @return Integer|null
535 public function getSize() {
540 * Returns the base36 sha1 of the text in this revision, or null if unknown.
542 * @return String|null
544 public function getSha1() {
549 * Returns the title of the page associated with this entry or null.
551 * Will do a query, when title is not set and id is given.
555 public function getTitle() {
556 if( isset( $this->mTitle
) ) {
557 return $this->mTitle
;
559 if( !is_null( $this->mId
) ) { //rev_id is defined as NOT NULL
560 $dbr = wfGetDB( DB_SLAVE
);
561 $row = $dbr->selectRow(
562 array( 'page', 'revision' ),
563 self
::selectPageFields(),
564 array( 'page_id=rev_page',
565 'rev_id' => $this->mId
),
568 $this->mTitle
= Title
::newFromRow( $row );
571 return $this->mTitle
;
575 * Set the title of the revision
577 * @param $title Title
579 public function setTitle( $title ) {
580 $this->mTitle
= $title;
586 * @return Integer|null
588 public function getPage() {
593 * Fetch revision's user id if it's available to the specified audience.
594 * If the specified audience does not have access to it, zero will be
597 * @param $audience Integer: one of:
598 * Revision::FOR_PUBLIC to be displayed to all users
599 * Revision::FOR_THIS_USER to be displayed to $wgUser
600 * Revision::RAW get the ID regardless of permissions
601 * @param $user User object to check for, only if FOR_THIS_USER is passed
602 * to the $audience parameter
605 public function getUser( $audience = self
::FOR_PUBLIC
, User
$user = null ) {
606 if( $audience == self
::FOR_PUBLIC
&& $this->isDeleted( self
::DELETED_USER
) ) {
608 } elseif( $audience == self
::FOR_THIS_USER
&& !$this->userCan( self
::DELETED_USER
, $user ) ) {
616 * Fetch revision's user id without regard for the current user's permissions
620 public function getRawUser() {
625 * Fetch revision's username if it's available to the specified audience.
626 * If the specified audience does not have access to the username, an
627 * empty string will be returned.
629 * @param $audience Integer: one of:
630 * Revision::FOR_PUBLIC to be displayed to all users
631 * Revision::FOR_THIS_USER to be displayed to $wgUser
632 * Revision::RAW get the text regardless of permissions
633 * @param $user User object to check for, only if FOR_THIS_USER is passed
634 * to the $audience parameter
637 public function getUserText( $audience = self
::FOR_PUBLIC
, User
$user = null ) {
638 if( $audience == self
::FOR_PUBLIC
&& $this->isDeleted( self
::DELETED_USER
) ) {
640 } elseif( $audience == self
::FOR_THIS_USER
&& !$this->userCan( self
::DELETED_USER
, $user ) ) {
643 return $this->getRawUserText();
648 * Fetch revision's username without regard for view restrictions
652 public function getRawUserText() {
653 if ( $this->mUserText
=== null ) {
654 $this->mUserText
= User
::whoIs( $this->mUser
); // load on demand
655 if ( $this->mUserText
=== false ) {
656 # This shouldn't happen, but it can if the wiki was recovered
657 # via importing revs and there is no user table entry yet.
658 $this->mUserText
= $this->mOrigUserText
;
661 return $this->mUserText
;
665 * Fetch revision comment if it's available to the specified audience.
666 * If the specified audience does not have access to the comment, an
667 * empty string will be returned.
669 * @param $audience Integer: one of:
670 * Revision::FOR_PUBLIC to be displayed to all users
671 * Revision::FOR_THIS_USER to be displayed to $wgUser
672 * Revision::RAW get the text regardless of permissions
673 * @param $user User object to check for, only if FOR_THIS_USER is passed
674 * to the $audience parameter
677 function getComment( $audience = self
::FOR_PUBLIC
, User
$user = null ) {
678 if( $audience == self
::FOR_PUBLIC
&& $this->isDeleted( self
::DELETED_COMMENT
) ) {
680 } elseif( $audience == self
::FOR_THIS_USER
&& !$this->userCan( self
::DELETED_COMMENT
, $user ) ) {
683 return $this->mComment
;
688 * Fetch revision comment without regard for the current user's permissions
692 public function getRawComment() {
693 return $this->mComment
;
699 public function isMinor() {
700 return (bool)$this->mMinorEdit
;
704 * @return Integer rcid of the unpatrolled row, zero if there isn't one
706 public function isUnpatrolled() {
707 if( $this->mUnpatrolled
!== null ) {
708 return $this->mUnpatrolled
;
710 $dbr = wfGetDB( DB_SLAVE
);
711 $this->mUnpatrolled
= $dbr->selectField( 'recentchanges',
713 array( // Add redundant user,timestamp condition so we can use the existing index
714 'rc_user_text' => $this->getRawUserText(),
715 'rc_timestamp' => $dbr->timestamp( $this->getTimestamp() ),
716 'rc_this_oldid' => $this->getId(),
721 return (int)$this->mUnpatrolled
;
725 * @param $field int one of DELETED_* bitfield constants
729 public function isDeleted( $field ) {
730 return ( $this->mDeleted
& $field ) == $field;
734 * Get the deletion bitfield of the revision
738 public function getVisibility() {
739 return (int)$this->mDeleted
;
743 * Fetch revision text if it's available to the specified audience.
744 * If the specified audience does not have the ability to view this
745 * revision, an empty string will be returned.
747 * @param $audience Integer: one of:
748 * Revision::FOR_PUBLIC to be displayed to all users
749 * Revision::FOR_THIS_USER to be displayed to $wgUser
750 * Revision::RAW get the text regardless of permissions
751 * @param $user User object to check for, only if FOR_THIS_USER is passed
752 * to the $audience parameter
755 public function getText( $audience = self
::FOR_PUBLIC
, User
$user = null ) {
756 if( $audience == self
::FOR_PUBLIC
&& $this->isDeleted( self
::DELETED_TEXT
) ) {
758 } elseif( $audience == self
::FOR_THIS_USER
&& !$this->userCan( self
::DELETED_TEXT
, $user ) ) {
761 return $this->getRawText();
766 * Alias for getText(Revision::FOR_THIS_USER)
768 * @deprecated since 1.17
771 public function revText() {
772 wfDeprecated( __METHOD__
, '1.17' );
773 return $this->getText( self
::FOR_THIS_USER
);
777 * Fetch revision text without regard for view restrictions
781 public function getRawText() {
782 if( is_null( $this->mText
) ) {
783 // Revision text is immutable. Load on demand:
784 $this->mText
= $this->loadText();
792 public function getTimestamp() {
793 return wfTimestamp( TS_MW
, $this->mTimestamp
);
799 public function isCurrent() {
800 return $this->mCurrent
;
804 * Get previous revision for this title
806 * @return Revision or null
808 public function getPrevious() {
809 if( $this->getTitle() ) {
810 $prev = $this->getTitle()->getPreviousRevisionID( $this->getId() );
812 return Revision
::newFromTitle( $this->getTitle(), $prev );
819 * Get next revision for this title
821 * @return Revision or null
823 public function getNext() {
824 if( $this->getTitle() ) {
825 $next = $this->getTitle()->getNextRevisionID( $this->getId() );
827 return Revision
::newFromTitle( $this->getTitle(), $next );
834 * Get previous revision Id for this page_id
835 * This is used to populate rev_parent_id on save
837 * @param $db DatabaseBase
840 private function getPreviousRevisionId( $db ) {
841 if( is_null( $this->mPage
) ) {
844 # Use page_latest if ID is not given
846 $prevId = $db->selectField( 'page', 'page_latest',
847 array( 'page_id' => $this->mPage
),
850 $prevId = $db->selectField( 'revision', 'rev_id',
851 array( 'rev_page' => $this->mPage
, 'rev_id < ' . $this->mId
),
853 array( 'ORDER BY' => 'rev_id DESC' ) );
855 return intval( $prevId );
859 * Get revision text associated with an old or archive row
860 * $row is usually an object from wfFetchRow(), both the flags and the text
861 * field must be included
863 * @param $row Object: the text data
864 * @param $prefix String: table prefix (default 'old_')
865 * @return String: text the text requested or false on failure
867 public static function getRevisionText( $row, $prefix = 'old_' ) {
868 wfProfileIn( __METHOD__
);
871 $textField = $prefix . 'text';
872 $flagsField = $prefix . 'flags';
874 if( isset( $row->$flagsField ) ) {
875 $flags = explode( ',', $row->$flagsField );
880 if( isset( $row->$textField ) ) {
881 $text = $row->$textField;
883 wfProfileOut( __METHOD__
);
887 # Use external methods for external objects, text in table is URL-only then
888 if ( in_array( 'external', $flags ) ) {
890 $parts = explode( '://', $url, 2 );
891 if( count( $parts ) == 1 ||
$parts[1] == '' ) {
892 wfProfileOut( __METHOD__
);
895 $text = ExternalStore
::fetchFromURL( $url );
898 // If the text was fetched without an error, convert it
899 if ( $text !== false ) {
900 if( in_array( 'gzip', $flags ) ) {
901 # Deal with optional compression of archived pages.
902 # This can be done periodically via maintenance/compressOld.php, and
903 # as pages are saved if $wgCompressRevisions is set.
904 $text = gzinflate( $text );
907 if( in_array( 'object', $flags ) ) {
908 # Generic compressed storage
909 $obj = unserialize( $text );
910 if ( !is_object( $obj ) ) {
912 wfProfileOut( __METHOD__
);
915 $text = $obj->getText();
918 global $wgLegacyEncoding;
919 if( $text !== false && $wgLegacyEncoding
920 && !in_array( 'utf-8', $flags ) && !in_array( 'utf8', $flags ) )
922 # Old revisions kept around in a legacy encoding?
923 # Upconvert on demand.
924 # ("utf8" checked for compatibility with some broken
925 # conversion scripts 2008-12-30)
927 $text = $wgContLang->iconv( $wgLegacyEncoding, 'UTF-8', $text );
930 wfProfileOut( __METHOD__
);
935 * If $wgCompressRevisions is enabled, we will compress data.
936 * The input string is modified in place.
937 * Return value is the flags field: contains 'gzip' if the
938 * data is compressed, and 'utf-8' if we're saving in UTF-8
941 * @param $text Mixed: reference to a text
944 public static function compressRevisionText( &$text ) {
945 global $wgCompressRevisions;
948 # Revisions not marked this way will be converted
949 # on load if $wgLegacyCharset is set in the future.
952 if( $wgCompressRevisions ) {
953 if( function_exists( 'gzdeflate' ) ) {
954 $text = gzdeflate( $text );
957 wfDebug( "Revision::compressRevisionText() -- no zlib support, not compressing\n" );
960 return implode( ',', $flags );
964 * Insert a new revision into the database, returning the new revision ID
965 * number on success and dies horribly on failure.
967 * @param $dbw DatabaseBase: (master connection)
970 public function insertOn( $dbw ) {
971 global $wgDefaultExternalStore;
973 wfProfileIn( __METHOD__
);
975 $data = $this->mText
;
976 $flags = Revision
::compressRevisionText( $data );
978 # Write to external storage if required
979 if( $wgDefaultExternalStore ) {
980 // Store and get the URL
981 $data = ExternalStore
::insertToDefault( $data );
983 throw new MWException( "Unable to store text to external storage" );
988 $flags .= 'external';
991 # Record the text (or external storage URL) to the text table
992 if( !isset( $this->mTextId
) ) {
993 $old_id = $dbw->nextSequenceValue( 'text_old_id_seq' );
994 $dbw->insert( 'text',
998 'old_flags' => $flags,
1001 $this->mTextId
= $dbw->insertId();
1004 if ( $this->mComment
=== null ) $this->mComment
= "";
1006 # Record the edit in revisions
1007 $rev_id = isset( $this->mId
)
1009 : $dbw->nextSequenceValue( 'revision_rev_id_seq' );
1010 $dbw->insert( 'revision',
1012 'rev_id' => $rev_id,
1013 'rev_page' => $this->mPage
,
1014 'rev_text_id' => $this->mTextId
,
1015 'rev_comment' => $this->mComment
,
1016 'rev_minor_edit' => $this->mMinorEdit ?
1 : 0,
1017 'rev_user' => $this->mUser
,
1018 'rev_user_text' => $this->mUserText
,
1019 'rev_timestamp' => $dbw->timestamp( $this->mTimestamp
),
1020 'rev_deleted' => $this->mDeleted
,
1021 'rev_len' => $this->mSize
,
1022 'rev_parent_id' => is_null( $this->mParentId
)
1023 ?
$this->getPreviousRevisionId( $dbw )
1025 'rev_sha1' => is_null( $this->mSha1
)
1026 ? Revision
::base36Sha1( $this->mText
)
1031 $this->mId
= !is_null( $rev_id ) ?
$rev_id : $dbw->insertId();
1033 wfRunHooks( 'RevisionInsertComplete', array( &$this, $data, $flags ) );
1035 wfProfileOut( __METHOD__
);
1040 * Get the base 36 SHA-1 value for a string of text
1041 * @param $text String
1044 public static function base36Sha1( $text ) {
1045 return wfBaseConvert( sha1( $text ), 16, 36, 31 );
1049 * Lazy-load the revision's text.
1050 * Currently hardcoded to the 'text' table storage engine.
1054 protected function loadText() {
1055 wfProfileIn( __METHOD__
);
1057 // Caching may be beneficial for massive use of external storage
1058 global $wgRevisionCacheExpiry, $wgMemc;
1059 $textId = $this->getTextId();
1060 $key = wfMemcKey( 'revisiontext', 'textid', $textId );
1061 if( $wgRevisionCacheExpiry ) {
1062 $text = $wgMemc->get( $key );
1063 if( is_string( $text ) ) {
1064 wfDebug( __METHOD__
. ": got id $textId from cache\n" );
1065 wfProfileOut( __METHOD__
);
1070 // If we kept data for lazy extraction, use it now...
1071 if ( isset( $this->mTextRow
) ) {
1072 $row = $this->mTextRow
;
1073 $this->mTextRow
= null;
1079 // Text data is immutable; check slaves first.
1080 $dbr = wfGetDB( DB_SLAVE
);
1081 $row = $dbr->selectRow( 'text',
1082 array( 'old_text', 'old_flags' ),
1083 array( 'old_id' => $this->getTextId() ),
1087 if( !$row && wfGetLB()->getServerCount() > 1 ) {
1088 // Possible slave lag!
1089 $dbw = wfGetDB( DB_MASTER
);
1090 $row = $dbw->selectRow( 'text',
1091 array( 'old_text', 'old_flags' ),
1092 array( 'old_id' => $this->getTextId() ),
1096 $text = self
::getRevisionText( $row );
1098 # No negative caching -- negative hits on text rows may be due to corrupted slave servers
1099 if( $wgRevisionCacheExpiry && $text !== false ) {
1100 $wgMemc->set( $key, $text, $wgRevisionCacheExpiry );
1103 wfProfileOut( __METHOD__
);
1109 * Create a new null-revision for insertion into a page's
1110 * history. This will not re-save the text, but simply refer
1111 * to the text from the previous version.
1113 * Such revisions can for instance identify page rename
1114 * operations and other such meta-modifications.
1116 * @param $dbw DatabaseBase
1117 * @param $pageId Integer: ID number of the page to read from
1118 * @param $summary String: revision's summary
1119 * @param $minor Boolean: whether the revision should be considered as minor
1120 * @return Revision|null on error
1122 public static function newNullRevision( $dbw, $pageId, $summary, $minor ) {
1123 wfProfileIn( __METHOD__
);
1125 $current = $dbw->selectRow(
1126 array( 'page', 'revision' ),
1127 array( 'page_latest', 'page_namespace', 'page_title',
1128 'rev_text_id', 'rev_len', 'rev_sha1' ),
1130 'page_id' => $pageId,
1131 'page_latest=rev_id',
1136 $revision = new Revision( array(
1138 'comment' => $summary,
1139 'minor_edit' => $minor,
1140 'text_id' => $current->rev_text_id
,
1141 'parent_id' => $current->page_latest
,
1142 'len' => $current->rev_len
,
1143 'sha1' => $current->rev_sha1
1145 $revision->setTitle( Title
::makeTitle( $current->page_namespace
, $current->page_title
) );
1150 wfProfileOut( __METHOD__
);
1155 * Determine if the current user is allowed to view a particular
1156 * field of this revision, if it's marked as deleted.
1158 * @param $field Integer:one of self::DELETED_TEXT,
1159 * self::DELETED_COMMENT,
1160 * self::DELETED_USER
1161 * @param $user User object to check, or null to use $wgUser
1164 public function userCan( $field, User
$user = null ) {
1165 return self
::userCanBitfield( $this->mDeleted
, $field, $user );
1169 * Determine if the current user is allowed to view a particular
1170 * field of this revision, if it's marked as deleted. This is used
1171 * by various classes to avoid duplication.
1173 * @param $bitfield Integer: current field
1174 * @param $field Integer: one of self::DELETED_TEXT = File::DELETED_FILE,
1175 * self::DELETED_COMMENT = File::DELETED_COMMENT,
1176 * self::DELETED_USER = File::DELETED_USER
1177 * @param $user User object to check, or null to use $wgUser
1180 public static function userCanBitfield( $bitfield, $field, User
$user = null ) {
1181 if( $bitfield & $field ) { // aspect is deleted
1182 if ( $bitfield & self
::DELETED_RESTRICTED
) {
1183 $permission = 'suppressrevision';
1184 } elseif ( $field & self
::DELETED_TEXT
) {
1185 $permission = 'deletedtext';
1187 $permission = 'deletedhistory';
1189 wfDebug( "Checking for $permission due to $field match on $bitfield\n" );
1190 if ( $user === null ) {
1194 return $user->isAllowed( $permission );
1201 * Get rev_timestamp from rev_id, without loading the rest of the row
1203 * @param $title Title
1204 * @param $id Integer
1207 static function getTimestampFromId( $title, $id ) {
1208 $dbr = wfGetDB( DB_SLAVE
);
1209 // Casting fix for DB2
1213 $conds = array( 'rev_id' => $id );
1214 $conds['rev_page'] = $title->getArticleID();
1215 $timestamp = $dbr->selectField( 'revision', 'rev_timestamp', $conds, __METHOD__
);
1216 if ( $timestamp === false && wfGetLB()->getServerCount() > 1 ) {
1217 # Not in slave, try master
1218 $dbw = wfGetDB( DB_MASTER
);
1219 $timestamp = $dbw->selectField( 'revision', 'rev_timestamp', $conds, __METHOD__
);
1221 return wfTimestamp( TS_MW
, $timestamp );
1225 * Get count of revisions per page...not very efficient
1227 * @param $db DatabaseBase
1228 * @param $id Integer: page id
1231 static function countByPageId( $db, $id ) {
1232 $row = $db->selectRow( 'revision', 'COUNT(*) AS revCount',
1233 array( 'rev_page' => $id ), __METHOD__
);
1235 return $row->revCount
;
1241 * Get count of revisions per page...not very efficient
1243 * @param $db DatabaseBase
1244 * @param $title Title
1247 static function countByTitle( $db, $title ) {
1248 $id = $title->getArticleID();
1250 return Revision
::countByPageId( $db, $id );